<?php
	$selectedDept = $_REQUEST['select'];
	mysql_query("SELECT Fname, Mname, Lname FROM academic_advisor WHERE Department = '$selectedDept'");
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Help : Academic Advisor</title>
<!--script src="lib/jquery/jquery-1.3.2.js"--><!--/script-->
<!--script src="http://code.google.com/apis/gears/gears_init.js"--><!--/script-->
<!--script src="js/mainPage.js"--> <!--/script-->
</head>
<!--------------------------------------------------------Design part of the code---------------------------------------------->
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginheight="0" marginwidth="0" bgcolor="#000066">

<table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#000066">
  <tr>
  <td><img src="../images/jsu_banner.jpg"></td>
  </tr>
</table>

<table border="0" width="100%" bgcolor="#000000" cellspacing="0" cellpadding="0">
  <tr>
  <center><td width="100%"><font color="#FFFFFF" face="Arial" size="2"><b>D.O.R.S. Jackson State University Edition</b></font></td></center>
  </tr>
</table>

<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="18%" bgcolor="#000066" valign="top">&nbsp;


<!------------------------------------------End of Design-------------------------------------------------------->


<center>
<img src="../images/logo.jpg">
</center>

<center>
<form name="chooseAdvisor" method="post" action="advisorpage2.php">
<select name="selectedDept" onchange="javascript:document.chooseAdvisor.submit();">
  <option>Select A Department</option>
  <option value ="general">Undecided</option>
  <option value= "honors college">Honors College</option>
  <option value= "accounting">Accounting</option>
  <option value= "art">Art</option>
  <option value= "biology">Biology</option>
  <option value= "Business Administration">Business Administration</option>
  <option value= "Chemistry">Chemistry</option>
  <option value= "Child Care & Family Education">Child Care & Family Education</option>
  <option value= "Civil Engineering">Civil Engineering</option>
  <option value= "Communicative Disorders">Communicative Disorders</option>
  <option value= "Computer Engineering">Computer Engineering</option>
  <option value= "Computer Science">Computer Science</option>
  <option value= "Criminal Justice">Criminal Justice</option>
  <option value= "Earth System Sciences">Earth System Sciences</option>
  <option value= "economics">Economics</option>
  <option value= "Elementary Education">Elementary Education</option>
  <option value= "english">English</option>
  <option value= "entrepreneurship">Entrepreneurship</option>
  <option value= "finance">Finance</option>
  <option value= "Health Care Administration">Health Care Administration</option>
  <option value= "Health">Health, Physical Education & Recreation</option>
  <option value= "history">History</option>
  <option value= "Industrial Technology">Industrial Technology</option>
  <option value= "management">Management</option>
  <option value= "marketing">Marketing</option>
  <option value= "Mass Communications">Mass Communications</option>
  <option value= "Mathematics">Mathematics</option>
  <option value= "Mathematics Education">Mathematics Education</option>
  <option value= "meteorology">Meteorology</option>
  <option value= "Modern Languages">Modern Languages</option>
  <option value= "Music Education">Music Education</option>
  <option value= "music performance">Music Performance</option>
  <option value= "philosophy">Philosophy</option>
  <option value= "physics">Physics</option>
  <option value= "Political Science">Political Science</option>
  <option value= "Professional Interdisciplinary Studies">Professional Interdisciplinary Studies</option>
  <option value= "psychology">Psychology</option>
  <option value= "Social Science Education">Social Science Education</option>
  <option value= "Social Work">Social Work</option>
  <option value= "sociology">Sociology</option>
  <option value= "Speech Communication & Theatre">Speech Communication & Theatre</option>
  <option value= "Special Education">Special Education</option>
  <option value= "Telecommunications Engineering">Telecommunications Engineering</option>
  <option value= "Urban Studies">Urban Studies</option>
</select>
</form>
</center>
<center>
<FORM action= "advisorPage2.php"> 
<INPUT type="button" value="Back" name="button1" onClick="history.go(-1); return true;">  
<INPUT type="submit" value="Ok" name="button2">
</FORM>
</center>